package com.wms.mapper;

import com.wms.domain.Emp;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;
import java.util.List;

@Mapper
public interface EmpMapper {
    @Select("select count(*) from emp")
    long count();

    //@Select("select * from emp   limit #{start}, #{End}")
    List<Emp> findByPage(int start, int End, String name, Short gender, LocalDateTime begin, LocalDateTime end);

    void delete(List<Integer> ids);

    @Insert("insert into emp(username, name, gender, image, job, entrydate, dept_id, create_time, update_time) " +
            "VALUES(#{username},#{name},#{gender},#{image},#{job},#{entrydate},#{deptId},#{createTime},#{updateTime})")
    void insert(Emp emp);

    @Select("select * from emp where id = #{id}")
    Emp findById(Integer id);

    void update(Emp emp);

    @Select("select * from emp where username = #{username} and password = #{password}")
    Emp getBynameandPassword(Emp emp);

    @Delete("delete  from emp where dept_id = #{dept_id}")
    void deleteByDeptId(int id);
}
